package com.chhuang.huaao.po;

import java.util.ArrayList;
import java.util.List;

/**
* HaCustomer ModelExample
* @author ChHuang
* @date Sun Apr 16 08:43:49 CST 2017
*/
public class HaCustomerExample {
	protected String orderByClause;
	protected boolean distinct;
	protected List<Criteria> oredCriteria;
	private Integer limit;
	private Integer offset;
	public HaCustomerExample() {
		oredCriteria = new ArrayList<Criteria>();
	}
	public void setOrderByClause(String orderByClause) {
		this.orderByClause = orderByClause;
	}
	public String getOrderByClause() {
		return orderByClause;
	}
	public void setDistinct(boolean distinct) {
		this.distinct = distinct;
	}
	public boolean isDistinct() {
		return distinct;
	}
	public List<Criteria> getOredCriteria() {
		return oredCriteria;
	}
	public void or(Criteria criteria) {
		oredCriteria.add(criteria);
	}
	public Criteria or() {
		Criteria criteria = createCriteriaInternal();
		oredCriteria.add(criteria);
		return criteria;
	}
	public Criteria createCriteria() {
		Criteria criteria = createCriteriaInternal();
		if (oredCriteria.size() == 0) {
			oredCriteria.add(criteria);
		}
		return criteria;
	}
	protected Criteria createCriteriaInternal() {
		Criteria criteria = new Criteria();
		return criteria;
	}
	public void clear() {
		oredCriteria.clear();
		orderByClause = null;
		distinct = false;
	}
	public void setLimit(Integer limit) {
		this.limit = limit;
	}
	public Integer getLimit() {
		return limit;
	}
	public void setOffset(Integer offset) {
		this.offset = offset;
	}
	public Integer getOffset() {
		return offset;
	}
	protected abstract static class GeneratedCriteria {
		protected List<Criterion> criteria;
		protected GeneratedCriteria() {
			super();
			criteria = new ArrayList<Criterion>();
		}
		public boolean isValid() {
			return criteria.size() > 0;
		}
		public List<Criterion> getAllCriteria() {
			return criteria;
		}
		public List<Criterion> getCriteria() {
			return criteria;
		}
		protected void addCriterion(String condition) {
			if (condition == null) {
				throw new RuntimeException("Value for condition cannot be null");
			}
			criteria.add(new Criterion(condition));
		}
		protected void addCriterion(String condition, Object value, String property) {
			if (value == null) {
				throw new RuntimeException("Value for " + property + " cannot be null");
			}
			criteria.add(new Criterion(condition, value));
		}
		protected void addCriterion(String condition, Object value1, Object value2, String property) {
			if (value1 == null || value2 == null) {
				throw new RuntimeException("Between values for " + property + " cannot be null");
			}
			criteria.add(new Criterion(condition, value1, value2));
		}
		
		public Criteria andCustomerIdIsNull() {
            addCriterion("CUSTOMER_ID is null");
            return (Criteria) this;
        }
        public Criteria andCustomerIdIsNotNull() {
            addCriterion("CUSTOMER_ID is not null");
            return (Criteria) this;
        }
        public Criteria andCustomerIdEqualTo(String value) {
            addCriterion("CUSTOMER_ID =", value, "customerId");
            return (Criteria) this;
        }
        public Criteria andCustomerIdNotEqualTo(String value) {
            addCriterion("CUSTOMER_ID <>", value, "customerId");
            return (Criteria) this;
        }
        public Criteria andCustomerIdGreaterThan(String value) {
            addCriterion("CUSTOMER_ID >", value, "customerId");
            return (Criteria) this;
        }
        public Criteria andCustomerIdGreaterThanOrEqualTo(String value) {
            addCriterion("CUSTOMER_ID >=", value, "customerId");
            return (Criteria) this;
        }
        public Criteria andCustomerIdLessThan(String value) {
            addCriterion("CUSTOMER_ID <", value, "customerId");
            return (Criteria) this;
        }
        public Criteria andCustomerIdLessThanOrEqualTo(String value) {
            addCriterion("CUSTOMER_ID <=", value, "customerId");
            return (Criteria) this;
        }
        public Criteria andCustomerIdLike(String value) {
            addCriterion("CUSTOMER_ID like", value, "customerId");
            return (Criteria) this;
        }
        public Criteria andCustomerIdNotLike(String value) {
            addCriterion("CUSTOMER_ID not like", value, "customerId");
            return (Criteria) this;
        }
        public Criteria andCustomerIdIn(List<String> values) {
            addCriterion("CUSTOMER_ID in", values, "customerId");
            return (Criteria) this;
        }
        public Criteria andCustomerIdNotIn(List<String> values) {
            addCriterion("CUSTOMER_ID not in", values, "customerId");
            return (Criteria) this;
        }
        public Criteria andCustomerIdBetween(String value1, String value2) {
            addCriterion("CUSTOMER_ID between", value1, value2, "customerId");
            return (Criteria) this;
        }
        public Criteria andCustomerIdNotBetween(String value1, String value2) {
            addCriterion("CUSTOMER_ID not between", value1, value2, "customerId");
            return (Criteria) this;
        }
		public Criteria andCustomerAccountIsNull() {
            addCriterion("CUSTOMER_ACCOUNT is null");
            return (Criteria) this;
        }
        public Criteria andCustomerAccountIsNotNull() {
            addCriterion("CUSTOMER_ACCOUNT is not null");
            return (Criteria) this;
        }
        public Criteria andCustomerAccountEqualTo(String value) {
            addCriterion("CUSTOMER_ACCOUNT =", value, "customerAccount");
            return (Criteria) this;
        }
        public Criteria andCustomerAccountNotEqualTo(String value) {
            addCriterion("CUSTOMER_ACCOUNT <>", value, "customerAccount");
            return (Criteria) this;
        }
        public Criteria andCustomerAccountGreaterThan(String value) {
            addCriterion("CUSTOMER_ACCOUNT >", value, "customerAccount");
            return (Criteria) this;
        }
        public Criteria andCustomerAccountGreaterThanOrEqualTo(String value) {
            addCriterion("CUSTOMER_ACCOUNT >=", value, "customerAccount");
            return (Criteria) this;
        }
        public Criteria andCustomerAccountLessThan(String value) {
            addCriterion("CUSTOMER_ACCOUNT <", value, "customerAccount");
            return (Criteria) this;
        }
        public Criteria andCustomerAccountLessThanOrEqualTo(String value) {
            addCriterion("CUSTOMER_ACCOUNT <=", value, "customerAccount");
            return (Criteria) this;
        }
        public Criteria andCustomerAccountLike(String value) {
            addCriterion("CUSTOMER_ACCOUNT like", value, "customerAccount");
            return (Criteria) this;
        }
        public Criteria andCustomerAccountNotLike(String value) {
            addCriterion("CUSTOMER_ACCOUNT not like", value, "customerAccount");
            return (Criteria) this;
        }
        public Criteria andCustomerAccountIn(List<String> values) {
            addCriterion("CUSTOMER_ACCOUNT in", values, "customerAccount");
            return (Criteria) this;
        }
        public Criteria andCustomerAccountNotIn(List<String> values) {
            addCriterion("CUSTOMER_ACCOUNT not in", values, "customerAccount");
            return (Criteria) this;
        }
        public Criteria andCustomerAccountBetween(String value1, String value2) {
            addCriterion("CUSTOMER_ACCOUNT between", value1, value2, "customerAccount");
            return (Criteria) this;
        }
        public Criteria andCustomerAccountNotBetween(String value1, String value2) {
            addCriterion("CUSTOMER_ACCOUNT not between", value1, value2, "customerAccount");
            return (Criteria) this;
        }
		public Criteria andCustomerPhoneIsNull() {
            addCriterion("CUSTOMER_PHONE is null");
            return (Criteria) this;
        }
        public Criteria andCustomerPhoneIsNotNull() {
            addCriterion("CUSTOMER_PHONE is not null");
            return (Criteria) this;
        }
        public Criteria andCustomerPhoneEqualTo(String value) {
            addCriterion("CUSTOMER_PHONE =", value, "customerPhone");
            return (Criteria) this;
        }
        public Criteria andCustomerPhoneNotEqualTo(String value) {
            addCriterion("CUSTOMER_PHONE <>", value, "customerPhone");
            return (Criteria) this;
        }
        public Criteria andCustomerPhoneGreaterThan(String value) {
            addCriterion("CUSTOMER_PHONE >", value, "customerPhone");
            return (Criteria) this;
        }
        public Criteria andCustomerPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("CUSTOMER_PHONE >=", value, "customerPhone");
            return (Criteria) this;
        }
        public Criteria andCustomerPhoneLessThan(String value) {
            addCriterion("CUSTOMER_PHONE <", value, "customerPhone");
            return (Criteria) this;
        }
        public Criteria andCustomerPhoneLessThanOrEqualTo(String value) {
            addCriterion("CUSTOMER_PHONE <=", value, "customerPhone");
            return (Criteria) this;
        }
        public Criteria andCustomerPhoneLike(String value) {
            addCriterion("CUSTOMER_PHONE like", value, "customerPhone");
            return (Criteria) this;
        }
        public Criteria andCustomerPhoneNotLike(String value) {
            addCriterion("CUSTOMER_PHONE not like", value, "customerPhone");
            return (Criteria) this;
        }
        public Criteria andCustomerPhoneIn(List<String> values) {
            addCriterion("CUSTOMER_PHONE in", values, "customerPhone");
            return (Criteria) this;
        }
        public Criteria andCustomerPhoneNotIn(List<String> values) {
            addCriterion("CUSTOMER_PHONE not in", values, "customerPhone");
            return (Criteria) this;
        }
        public Criteria andCustomerPhoneBetween(String value1, String value2) {
            addCriterion("CUSTOMER_PHONE between", value1, value2, "customerPhone");
            return (Criteria) this;
        }
        public Criteria andCustomerPhoneNotBetween(String value1, String value2) {
            addCriterion("CUSTOMER_PHONE not between", value1, value2, "customerPhone");
            return (Criteria) this;
        }
		public Criteria andCustomerPasswordIsNull() {
            addCriterion("CUSTOMER_PASSWORD is null");
            return (Criteria) this;
        }
        public Criteria andCustomerPasswordIsNotNull() {
            addCriterion("CUSTOMER_PASSWORD is not null");
            return (Criteria) this;
        }
        public Criteria andCustomerPasswordEqualTo(String value) {
            addCriterion("CUSTOMER_PASSWORD =", value, "customerPassword");
            return (Criteria) this;
        }
        public Criteria andCustomerPasswordNotEqualTo(String value) {
            addCriterion("CUSTOMER_PASSWORD <>", value, "customerPassword");
            return (Criteria) this;
        }
        public Criteria andCustomerPasswordGreaterThan(String value) {
            addCriterion("CUSTOMER_PASSWORD >", value, "customerPassword");
            return (Criteria) this;
        }
        public Criteria andCustomerPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("CUSTOMER_PASSWORD >=", value, "customerPassword");
            return (Criteria) this;
        }
        public Criteria andCustomerPasswordLessThan(String value) {
            addCriterion("CUSTOMER_PASSWORD <", value, "customerPassword");
            return (Criteria) this;
        }
        public Criteria andCustomerPasswordLessThanOrEqualTo(String value) {
            addCriterion("CUSTOMER_PASSWORD <=", value, "customerPassword");
            return (Criteria) this;
        }
        public Criteria andCustomerPasswordLike(String value) {
            addCriterion("CUSTOMER_PASSWORD like", value, "customerPassword");
            return (Criteria) this;
        }
        public Criteria andCustomerPasswordNotLike(String value) {
            addCriterion("CUSTOMER_PASSWORD not like", value, "customerPassword");
            return (Criteria) this;
        }
        public Criteria andCustomerPasswordIn(List<String> values) {
            addCriterion("CUSTOMER_PASSWORD in", values, "customerPassword");
            return (Criteria) this;
        }
        public Criteria andCustomerPasswordNotIn(List<String> values) {
            addCriterion("CUSTOMER_PASSWORD not in", values, "customerPassword");
            return (Criteria) this;
        }
        public Criteria andCustomerPasswordBetween(String value1, String value2) {
            addCriterion("CUSTOMER_PASSWORD between", value1, value2, "customerPassword");
            return (Criteria) this;
        }
        public Criteria andCustomerPasswordNotBetween(String value1, String value2) {
            addCriterion("CUSTOMER_PASSWORD not between", value1, value2, "customerPassword");
            return (Criteria) this;
        }
		public Criteria andCustomerNameIsNull() {
            addCriterion("CUSTOMER_NAME is null");
            return (Criteria) this;
        }
        public Criteria andCustomerNameIsNotNull() {
            addCriterion("CUSTOMER_NAME is not null");
            return (Criteria) this;
        }
        public Criteria andCustomerNameEqualTo(String value) {
            addCriterion("CUSTOMER_NAME =", value, "customerName");
            return (Criteria) this;
        }
        public Criteria andCustomerNameNotEqualTo(String value) {
            addCriterion("CUSTOMER_NAME <>", value, "customerName");
            return (Criteria) this;
        }
        public Criteria andCustomerNameGreaterThan(String value) {
            addCriterion("CUSTOMER_NAME >", value, "customerName");
            return (Criteria) this;
        }
        public Criteria andCustomerNameGreaterThanOrEqualTo(String value) {
            addCriterion("CUSTOMER_NAME >=", value, "customerName");
            return (Criteria) this;
        }
        public Criteria andCustomerNameLessThan(String value) {
            addCriterion("CUSTOMER_NAME <", value, "customerName");
            return (Criteria) this;
        }
        public Criteria andCustomerNameLessThanOrEqualTo(String value) {
            addCriterion("CUSTOMER_NAME <=", value, "customerName");
            return (Criteria) this;
        }
        public Criteria andCustomerNameLike(String value) {
            addCriterion("CUSTOMER_NAME like", value, "customerName");
            return (Criteria) this;
        }
        public Criteria andCustomerNameNotLike(String value) {
            addCriterion("CUSTOMER_NAME not like", value, "customerName");
            return (Criteria) this;
        }
        public Criteria andCustomerNameIn(List<String> values) {
            addCriterion("CUSTOMER_NAME in", values, "customerName");
            return (Criteria) this;
        }
        public Criteria andCustomerNameNotIn(List<String> values) {
            addCriterion("CUSTOMER_NAME not in", values, "customerName");
            return (Criteria) this;
        }
        public Criteria andCustomerNameBetween(String value1, String value2) {
            addCriterion("CUSTOMER_NAME between", value1, value2, "customerName");
            return (Criteria) this;
        }
        public Criteria andCustomerNameNotBetween(String value1, String value2) {
            addCriterion("CUSTOMER_NAME not between", value1, value2, "customerName");
            return (Criteria) this;
        }
		public Criteria andCustomerGenderIsNull() {
            addCriterion("CUSTOMER_GENDER is null");
            return (Criteria) this;
        }
        public Criteria andCustomerGenderIsNotNull() {
            addCriterion("CUSTOMER_GENDER is not null");
            return (Criteria) this;
        }
        public Criteria andCustomerGenderEqualTo(Integer value) {
            addCriterion("CUSTOMER_GENDER =", value, "customerGender");
            return (Criteria) this;
        }
        public Criteria andCustomerGenderNotEqualTo(Boolean value) {
            addCriterion("CUSTOMER_GENDER <>", value, "customerGender");
            return (Criteria) this;
        }
        public Criteria andCustomerGenderGreaterThan(Boolean value) {
            addCriterion("CUSTOMER_GENDER >", value, "customerGender");
            return (Criteria) this;
        }
        public Criteria andCustomerGenderGreaterThanOrEqualTo(Boolean value) {
            addCriterion("CUSTOMER_GENDER >=", value, "customerGender");
            return (Criteria) this;
        }
        public Criteria andCustomerGenderLessThan(Boolean value) {
            addCriterion("CUSTOMER_GENDER <", value, "customerGender");
            return (Criteria) this;
        }
        public Criteria andCustomerGenderLessThanOrEqualTo(Boolean value) {
            addCriterion("CUSTOMER_GENDER <=", value, "customerGender");
            return (Criteria) this;
        }
        public Criteria andCustomerGenderLike(Boolean value) {
            addCriterion("CUSTOMER_GENDER like", value, "customerGender");
            return (Criteria) this;
        }
        public Criteria andCustomerGenderNotLike(Boolean value) {
            addCriterion("CUSTOMER_GENDER not like", value, "customerGender");
            return (Criteria) this;
        }
        public Criteria andCustomerGenderIn(List<Boolean> values) {
            addCriterion("CUSTOMER_GENDER in", values, "customerGender");
            return (Criteria) this;
        }
        public Criteria andCustomerGenderNotIn(List<Boolean> values) {
            addCriterion("CUSTOMER_GENDER not in", values, "customerGender");
            return (Criteria) this;
        }
        public Criteria andCustomerGenderBetween(Boolean value1, Boolean value2) {
            addCriterion("CUSTOMER_GENDER between", value1, value2, "customerGender");
            return (Criteria) this;
        }
        public Criteria andCustomerGenderNotBetween(Boolean value1, Boolean value2) {
            addCriterion("CUSTOMER_GENDER not between", value1, value2, "customerGender");
            return (Criteria) this;
        }
		public Criteria andCustomerCompanyIsNull() {
            addCriterion("CUSTOMER_COMPANY is null");
            return (Criteria) this;
        }
        public Criteria andCustomerCompanyIsNotNull() {
            addCriterion("CUSTOMER_COMPANY is not null");
            return (Criteria) this;
        }
        public Criteria andCustomerCompanyEqualTo(String value) {
            addCriterion("CUSTOMER_COMPANY =", value, "customerCompany");
            return (Criteria) this;
        }
        public Criteria andCustomerCompanyNotEqualTo(String value) {
            addCriterion("CUSTOMER_COMPANY <>", value, "customerCompany");
            return (Criteria) this;
        }
        public Criteria andCustomerCompanyGreaterThan(String value) {
            addCriterion("CUSTOMER_COMPANY >", value, "customerCompany");
            return (Criteria) this;
        }
        public Criteria andCustomerCompanyGreaterThanOrEqualTo(String value) {
            addCriterion("CUSTOMER_COMPANY >=", value, "customerCompany");
            return (Criteria) this;
        }
        public Criteria andCustomerCompanyLessThan(String value) {
            addCriterion("CUSTOMER_COMPANY <", value, "customerCompany");
            return (Criteria) this;
        }
        public Criteria andCustomerCompanyLessThanOrEqualTo(String value) {
            addCriterion("CUSTOMER_COMPANY <=", value, "customerCompany");
            return (Criteria) this;
        }
        public Criteria andCustomerCompanyLike(String value) {
            addCriterion("CUSTOMER_COMPANY like", value, "customerCompany");
            return (Criteria) this;
        }
        public Criteria andCustomerCompanyNotLike(String value) {
            addCriterion("CUSTOMER_COMPANY not like", value, "customerCompany");
            return (Criteria) this;
        }
        public Criteria andCustomerCompanyIn(List<String> values) {
            addCriterion("CUSTOMER_COMPANY in", values, "customerCompany");
            return (Criteria) this;
        }
        public Criteria andCustomerCompanyNotIn(List<String> values) {
            addCriterion("CUSTOMER_COMPANY not in", values, "customerCompany");
            return (Criteria) this;
        }
        public Criteria andCustomerCompanyBetween(String value1, String value2) {
            addCriterion("CUSTOMER_COMPANY between", value1, value2, "customerCompany");
            return (Criteria) this;
        }
        public Criteria andCustomerCompanyNotBetween(String value1, String value2) {
            addCriterion("CUSTOMER_COMPANY not between", value1, value2, "customerCompany");
            return (Criteria) this;
        }
		public Criteria andCustomerPhotoIsNull() {
            addCriterion("CUSTOMER_PHOTO is null");
            return (Criteria) this;
        }
        public Criteria andCustomerPhotoIsNotNull() {
            addCriterion("CUSTOMER_PHOTO is not null");
            return (Criteria) this;
        }
        public Criteria andCustomerPhotoEqualTo(String value) {
            addCriterion("CUSTOMER_PHOTO =", value, "customerPhoto");
            return (Criteria) this;
        }
        public Criteria andCustomerPhotoNotEqualTo(String value) {
            addCriterion("CUSTOMER_PHOTO <>", value, "customerPhoto");
            return (Criteria) this;
        }
        public Criteria andCustomerPhotoGreaterThan(String value) {
            addCriterion("CUSTOMER_PHOTO >", value, "customerPhoto");
            return (Criteria) this;
        }
        public Criteria andCustomerPhotoGreaterThanOrEqualTo(String value) {
            addCriterion("CUSTOMER_PHOTO >=", value, "customerPhoto");
            return (Criteria) this;
        }
        public Criteria andCustomerPhotoLessThan(String value) {
            addCriterion("CUSTOMER_PHOTO <", value, "customerPhoto");
            return (Criteria) this;
        }
        public Criteria andCustomerPhotoLessThanOrEqualTo(String value) {
            addCriterion("CUSTOMER_PHOTO <=", value, "customerPhoto");
            return (Criteria) this;
        }
        public Criteria andCustomerPhotoLike(String value) {
            addCriterion("CUSTOMER_PHOTO like", value, "customerPhoto");
            return (Criteria) this;
        }
        public Criteria andCustomerPhotoNotLike(String value) {
            addCriterion("CUSTOMER_PHOTO not like", value, "customerPhoto");
            return (Criteria) this;
        }
        public Criteria andCustomerPhotoIn(List<String> values) {
            addCriterion("CUSTOMER_PHOTO in", values, "customerPhoto");
            return (Criteria) this;
        }
        public Criteria andCustomerPhotoNotIn(List<String> values) {
            addCriterion("CUSTOMER_PHOTO not in", values, "customerPhoto");
            return (Criteria) this;
        }
        public Criteria andCustomerPhotoBetween(String value1, String value2) {
            addCriterion("CUSTOMER_PHOTO between", value1, value2, "customerPhoto");
            return (Criteria) this;
        }
        public Criteria andCustomerPhotoNotBetween(String value1, String value2) {
            addCriterion("CUSTOMER_PHOTO not between", value1, value2, "customerPhoto");
            return (Criteria) this;
        }
		public Criteria andDeviceSystemIsNull() {
            addCriterion("DEVICE_SYSTEM is null");
            return (Criteria) this;
        }
        public Criteria andDeviceSystemIsNotNull() {
            addCriterion("DEVICE_SYSTEM is not null");
            return (Criteria) this;
        }
        public Criteria andDeviceSystemEqualTo(String value) {
            addCriterion("DEVICE_SYSTEM =", value, "deviceSystem");
            return (Criteria) this;
        }
        public Criteria andDeviceSystemNotEqualTo(String value) {
            addCriterion("DEVICE_SYSTEM <>", value, "deviceSystem");
            return (Criteria) this;
        }
        public Criteria andDeviceSystemGreaterThan(String value) {
            addCriterion("DEVICE_SYSTEM >", value, "deviceSystem");
            return (Criteria) this;
        }
        public Criteria andDeviceSystemGreaterThanOrEqualTo(String value) {
            addCriterion("DEVICE_SYSTEM >=", value, "deviceSystem");
            return (Criteria) this;
        }
        public Criteria andDeviceSystemLessThan(String value) {
            addCriterion("DEVICE_SYSTEM <", value, "deviceSystem");
            return (Criteria) this;
        }
        public Criteria andDeviceSystemLessThanOrEqualTo(String value) {
            addCriterion("DEVICE_SYSTEM <=", value, "deviceSystem");
            return (Criteria) this;
        }
        public Criteria andDeviceSystemLike(String value) {
            addCriterion("DEVICE_SYSTEM like", value, "deviceSystem");
            return (Criteria) this;
        }
        public Criteria andDeviceSystemNotLike(String value) {
            addCriterion("DEVICE_SYSTEM not like", value, "deviceSystem");
            return (Criteria) this;
        }
        public Criteria andDeviceSystemIn(List<String> values) {
            addCriterion("DEVICE_SYSTEM in", values, "deviceSystem");
            return (Criteria) this;
        }
        public Criteria andDeviceSystemNotIn(List<String> values) {
            addCriterion("DEVICE_SYSTEM not in", values, "deviceSystem");
            return (Criteria) this;
        }
        public Criteria andDeviceSystemBetween(String value1, String value2) {
            addCriterion("DEVICE_SYSTEM between", value1, value2, "deviceSystem");
            return (Criteria) this;
        }
        public Criteria andDeviceSystemNotBetween(String value1, String value2) {
            addCriterion("DEVICE_SYSTEM not between", value1, value2, "deviceSystem");
            return (Criteria) this;
        }
		public Criteria andDeviceModelIsNull() {
            addCriterion("DEVICE_MODEL is null");
            return (Criteria) this;
        }
        public Criteria andDeviceModelIsNotNull() {
            addCriterion("DEVICE_MODEL is not null");
            return (Criteria) this;
        }
        public Criteria andDeviceModelEqualTo(String value) {
            addCriterion("DEVICE_MODEL =", value, "deviceModel");
            return (Criteria) this;
        }
        public Criteria andDeviceModelNotEqualTo(String value) {
            addCriterion("DEVICE_MODEL <>", value, "deviceModel");
            return (Criteria) this;
        }
        public Criteria andDeviceModelGreaterThan(String value) {
            addCriterion("DEVICE_MODEL >", value, "deviceModel");
            return (Criteria) this;
        }
        public Criteria andDeviceModelGreaterThanOrEqualTo(String value) {
            addCriterion("DEVICE_MODEL >=", value, "deviceModel");
            return (Criteria) this;
        }
        public Criteria andDeviceModelLessThan(String value) {
            addCriterion("DEVICE_MODEL <", value, "deviceModel");
            return (Criteria) this;
        }
        public Criteria andDeviceModelLessThanOrEqualTo(String value) {
            addCriterion("DEVICE_MODEL <=", value, "deviceModel");
            return (Criteria) this;
        }
        public Criteria andDeviceModelLike(String value) {
            addCriterion("DEVICE_MODEL like", value, "deviceModel");
            return (Criteria) this;
        }
        public Criteria andDeviceModelNotLike(String value) {
            addCriterion("DEVICE_MODEL not like", value, "deviceModel");
            return (Criteria) this;
        }
        public Criteria andDeviceModelIn(List<String> values) {
            addCriterion("DEVICE_MODEL in", values, "deviceModel");
            return (Criteria) this;
        }
        public Criteria andDeviceModelNotIn(List<String> values) {
            addCriterion("DEVICE_MODEL not in", values, "deviceModel");
            return (Criteria) this;
        }
        public Criteria andDeviceModelBetween(String value1, String value2) {
            addCriterion("DEVICE_MODEL between", value1, value2, "deviceModel");
            return (Criteria) this;
        }
        public Criteria andDeviceModelNotBetween(String value1, String value2) {
            addCriterion("DEVICE_MODEL not between", value1, value2, "deviceModel");
            return (Criteria) this;
        }
		public Criteria andDeviceVendorIsNull() {
            addCriterion("DEVICE_VENDOR is null");
            return (Criteria) this;
        }
        public Criteria andDeviceVendorIsNotNull() {
            addCriterion("DEVICE_VENDOR is not null");
            return (Criteria) this;
        }
        public Criteria andDeviceVendorEqualTo(String value) {
            addCriterion("DEVICE_VENDOR =", value, "deviceVendor");
            return (Criteria) this;
        }
        public Criteria andDeviceVendorNotEqualTo(String value) {
            addCriterion("DEVICE_VENDOR <>", value, "deviceVendor");
            return (Criteria) this;
        }
        public Criteria andDeviceVendorGreaterThan(String value) {
            addCriterion("DEVICE_VENDOR >", value, "deviceVendor");
            return (Criteria) this;
        }
        public Criteria andDeviceVendorGreaterThanOrEqualTo(String value) {
            addCriterion("DEVICE_VENDOR >=", value, "deviceVendor");
            return (Criteria) this;
        }
        public Criteria andDeviceVendorLessThan(String value) {
            addCriterion("DEVICE_VENDOR <", value, "deviceVendor");
            return (Criteria) this;
        }
        public Criteria andDeviceVendorLessThanOrEqualTo(String value) {
            addCriterion("DEVICE_VENDOR <=", value, "deviceVendor");
            return (Criteria) this;
        }
        public Criteria andDeviceVendorLike(String value) {
            addCriterion("DEVICE_VENDOR like", value, "deviceVendor");
            return (Criteria) this;
        }
        public Criteria andDeviceVendorNotLike(String value) {
            addCriterion("DEVICE_VENDOR not like", value, "deviceVendor");
            return (Criteria) this;
        }
        public Criteria andDeviceVendorIn(List<String> values) {
            addCriterion("DEVICE_VENDOR in", values, "deviceVendor");
            return (Criteria) this;
        }
        public Criteria andDeviceVendorNotIn(List<String> values) {
            addCriterion("DEVICE_VENDOR not in", values, "deviceVendor");
            return (Criteria) this;
        }
        public Criteria andDeviceVendorBetween(String value1, String value2) {
            addCriterion("DEVICE_VENDOR between", value1, value2, "deviceVendor");
            return (Criteria) this;
        }
        public Criteria andDeviceVendorNotBetween(String value1, String value2) {
            addCriterion("DEVICE_VENDOR not between", value1, value2, "deviceVendor");
            return (Criteria) this;
        }
		public Criteria andDeviceUuidIsNull() {
            addCriterion("DEVICE_UUID is null");
            return (Criteria) this;
        }
        public Criteria andDeviceUuidIsNotNull() {
            addCriterion("DEVICE_UUID is not null");
            return (Criteria) this;
        }
        public Criteria andDeviceUuidEqualTo(String value) {
            addCriterion("DEVICE_UUID =", value, "deviceUuid");
            return (Criteria) this;
        }
        public Criteria andDeviceUuidNotEqualTo(String value) {
            addCriterion("DEVICE_UUID <>", value, "deviceUuid");
            return (Criteria) this;
        }
        public Criteria andDeviceUuidGreaterThan(String value) {
            addCriterion("DEVICE_UUID >", value, "deviceUuid");
            return (Criteria) this;
        }
        public Criteria andDeviceUuidGreaterThanOrEqualTo(String value) {
            addCriterion("DEVICE_UUID >=", value, "deviceUuid");
            return (Criteria) this;
        }
        public Criteria andDeviceUuidLessThan(String value) {
            addCriterion("DEVICE_UUID <", value, "deviceUuid");
            return (Criteria) this;
        }
        public Criteria andDeviceUuidLessThanOrEqualTo(String value) {
            addCriterion("DEVICE_UUID <=", value, "deviceUuid");
            return (Criteria) this;
        }
        public Criteria andDeviceUuidLike(String value) {
            addCriterion("DEVICE_UUID like", value, "deviceUuid");
            return (Criteria) this;
        }
        public Criteria andDeviceUuidNotLike(String value) {
            addCriterion("DEVICE_UUID not like", value, "deviceUuid");
            return (Criteria) this;
        }
        public Criteria andDeviceUuidIn(List<String> values) {
            addCriterion("DEVICE_UUID in", values, "deviceUuid");
            return (Criteria) this;
        }
        public Criteria andDeviceUuidNotIn(List<String> values) {
            addCriterion("DEVICE_UUID not in", values, "deviceUuid");
            return (Criteria) this;
        }
        public Criteria andDeviceUuidBetween(String value1, String value2) {
            addCriterion("DEVICE_UUID between", value1, value2, "deviceUuid");
            return (Criteria) this;
        }
        public Criteria andDeviceUuidNotBetween(String value1, String value2) {
            addCriterion("DEVICE_UUID not between", value1, value2, "deviceUuid");
            return (Criteria) this;
        }
		public Criteria andClientIdIsNull() {
            addCriterion("CLIENT_ID is null");
            return (Criteria) this;
        }
        public Criteria andClientIdIsNotNull() {
            addCriterion("CLIENT_ID is not null");
            return (Criteria) this;
        }
        public Criteria andClientIdEqualTo(String value) {
            addCriterion("CLIENT_ID =", value, "clientId");
            return (Criteria) this;
        }
        public Criteria andClientIdNotEqualTo(String value) {
            addCriterion("CLIENT_ID <>", value, "clientId");
            return (Criteria) this;
        }
        public Criteria andClientIdGreaterThan(String value) {
            addCriterion("CLIENT_ID >", value, "clientId");
            return (Criteria) this;
        }
        public Criteria andClientIdGreaterThanOrEqualTo(String value) {
            addCriterion("CLIENT_ID >=", value, "clientId");
            return (Criteria) this;
        }
        public Criteria andClientIdLessThan(String value) {
            addCriterion("CLIENT_ID <", value, "clientId");
            return (Criteria) this;
        }
        public Criteria andClientIdLessThanOrEqualTo(String value) {
            addCriterion("CLIENT_ID <=", value, "clientId");
            return (Criteria) this;
        }
        public Criteria andClientIdLike(String value) {
            addCriterion("CLIENT_ID like", value, "clientId");
            return (Criteria) this;
        }
        public Criteria andClientIdNotLike(String value) {
            addCriterion("CLIENT_ID not like", value, "clientId");
            return (Criteria) this;
        }
        public Criteria andClientIdIn(List<String> values) {
            addCriterion("CLIENT_ID in", values, "clientId");
            return (Criteria) this;
        }
        public Criteria andClientIdNotIn(List<String> values) {
            addCriterion("CLIENT_ID not in", values, "clientId");
            return (Criteria) this;
        }
        public Criteria andClientIdBetween(String value1, String value2) {
            addCriterion("CLIENT_ID between", value1, value2, "clientId");
            return (Criteria) this;
        }
        public Criteria andClientIdNotBetween(String value1, String value2) {
            addCriterion("CLIENT_ID not between", value1, value2, "clientId");
            return (Criteria) this;
        }
		public Criteria andClientVersionIsNull() {
            addCriterion("CLIENT_VERSION is null");
            return (Criteria) this;
        }
        public Criteria andClientVersionIsNotNull() {
            addCriterion("CLIENT_VERSION is not null");
            return (Criteria) this;
        }
        public Criteria andClientVersionEqualTo(String value) {
            addCriterion("CLIENT_VERSION =", value, "clientVersion");
            return (Criteria) this;
        }
        public Criteria andClientVersionNotEqualTo(String value) {
            addCriterion("CLIENT_VERSION <>", value, "clientVersion");
            return (Criteria) this;
        }
        public Criteria andClientVersionGreaterThan(String value) {
            addCriterion("CLIENT_VERSION >", value, "clientVersion");
            return (Criteria) this;
        }
        public Criteria andClientVersionGreaterThanOrEqualTo(String value) {
            addCriterion("CLIENT_VERSION >=", value, "clientVersion");
            return (Criteria) this;
        }
        public Criteria andClientVersionLessThan(String value) {
            addCriterion("CLIENT_VERSION <", value, "clientVersion");
            return (Criteria) this;
        }
        public Criteria andClientVersionLessThanOrEqualTo(String value) {
            addCriterion("CLIENT_VERSION <=", value, "clientVersion");
            return (Criteria) this;
        }
        public Criteria andClientVersionLike(String value) {
            addCriterion("CLIENT_VERSION like", value, "clientVersion");
            return (Criteria) this;
        }
        public Criteria andClientVersionNotLike(String value) {
            addCriterion("CLIENT_VERSION not like", value, "clientVersion");
            return (Criteria) this;
        }
        public Criteria andClientVersionIn(List<String> values) {
            addCriterion("CLIENT_VERSION in", values, "clientVersion");
            return (Criteria) this;
        }
        public Criteria andClientVersionNotIn(List<String> values) {
            addCriterion("CLIENT_VERSION not in", values, "clientVersion");
            return (Criteria) this;
        }
        public Criteria andClientVersionBetween(String value1, String value2) {
            addCriterion("CLIENT_VERSION between", value1, value2, "clientVersion");
            return (Criteria) this;
        }
        public Criteria andClientVersionNotBetween(String value1, String value2) {
            addCriterion("CLIENT_VERSION not between", value1, value2, "clientVersion");
            return (Criteria) this;
        }
		public Criteria andLastLoginAddressIsNull() {
            addCriterion("LAST_LOGIN_ADDRESS is null");
            return (Criteria) this;
        }
        public Criteria andLastLoginAddressIsNotNull() {
            addCriterion("LAST_LOGIN_ADDRESS is not null");
            return (Criteria) this;
        }
        public Criteria andLastLoginAddressEqualTo(String value) {
            addCriterion("LAST_LOGIN_ADDRESS =", value, "lastLoginAddress");
            return (Criteria) this;
        }
        public Criteria andLastLoginAddressNotEqualTo(String value) {
            addCriterion("LAST_LOGIN_ADDRESS <>", value, "lastLoginAddress");
            return (Criteria) this;
        }
        public Criteria andLastLoginAddressGreaterThan(String value) {
            addCriterion("LAST_LOGIN_ADDRESS >", value, "lastLoginAddress");
            return (Criteria) this;
        }
        public Criteria andLastLoginAddressGreaterThanOrEqualTo(String value) {
            addCriterion("LAST_LOGIN_ADDRESS >=", value, "lastLoginAddress");
            return (Criteria) this;
        }
        public Criteria andLastLoginAddressLessThan(String value) {
            addCriterion("LAST_LOGIN_ADDRESS <", value, "lastLoginAddress");
            return (Criteria) this;
        }
        public Criteria andLastLoginAddressLessThanOrEqualTo(String value) {
            addCriterion("LAST_LOGIN_ADDRESS <=", value, "lastLoginAddress");
            return (Criteria) this;
        }
        public Criteria andLastLoginAddressLike(String value) {
            addCriterion("LAST_LOGIN_ADDRESS like", value, "lastLoginAddress");
            return (Criteria) this;
        }
        public Criteria andLastLoginAddressNotLike(String value) {
            addCriterion("LAST_LOGIN_ADDRESS not like", value, "lastLoginAddress");
            return (Criteria) this;
        }
        public Criteria andLastLoginAddressIn(List<String> values) {
            addCriterion("LAST_LOGIN_ADDRESS in", values, "lastLoginAddress");
            return (Criteria) this;
        }
        public Criteria andLastLoginAddressNotIn(List<String> values) {
            addCriterion("LAST_LOGIN_ADDRESS not in", values, "lastLoginAddress");
            return (Criteria) this;
        }
        public Criteria andLastLoginAddressBetween(String value1, String value2) {
            addCriterion("LAST_LOGIN_ADDRESS between", value1, value2, "lastLoginAddress");
            return (Criteria) this;
        }
        public Criteria andLastLoginAddressNotBetween(String value1, String value2) {
            addCriterion("LAST_LOGIN_ADDRESS not between", value1, value2, "lastLoginAddress");
            return (Criteria) this;
        }
		public Criteria andLastLoginTimeIsNull() {
            addCriterion("LAST_LOGIN_TIME is null");
            return (Criteria) this;
        }
        public Criteria andLastLoginTimeIsNotNull() {
            addCriterion("LAST_LOGIN_TIME is not null");
            return (Criteria) this;
        }
        public Criteria andLastLoginTimeEqualTo(String value) {
            addCriterion("LAST_LOGIN_TIME =", value, "lastLoginTime");
            return (Criteria) this;
        }
        public Criteria andLastLoginTimeNotEqualTo(String value) {
            addCriterion("LAST_LOGIN_TIME <>", value, "lastLoginTime");
            return (Criteria) this;
        }
        public Criteria andLastLoginTimeGreaterThan(String value) {
            addCriterion("LAST_LOGIN_TIME >", value, "lastLoginTime");
            return (Criteria) this;
        }
        public Criteria andLastLoginTimeGreaterThanOrEqualTo(String value) {
            addCriterion("LAST_LOGIN_TIME >=", value, "lastLoginTime");
            return (Criteria) this;
        }
        public Criteria andLastLoginTimeLessThan(String value) {
            addCriterion("LAST_LOGIN_TIME <", value, "lastLoginTime");
            return (Criteria) this;
        }
        public Criteria andLastLoginTimeLessThanOrEqualTo(String value) {
            addCriterion("LAST_LOGIN_TIME <=", value, "lastLoginTime");
            return (Criteria) this;
        }
        public Criteria andLastLoginTimeLike(String value) {
            addCriterion("LAST_LOGIN_TIME like", value, "lastLoginTime");
            return (Criteria) this;
        }
        public Criteria andLastLoginTimeNotLike(String value) {
            addCriterion("LAST_LOGIN_TIME not like", value, "lastLoginTime");
            return (Criteria) this;
        }
        public Criteria andLastLoginTimeIn(List<String> values) {
            addCriterion("LAST_LOGIN_TIME in", values, "lastLoginTime");
            return (Criteria) this;
        }
        public Criteria andLastLoginTimeNotIn(List<String> values) {
            addCriterion("LAST_LOGIN_TIME not in", values, "lastLoginTime");
            return (Criteria) this;
        }
        public Criteria andLastLoginTimeBetween(String value1, String value2) {
            addCriterion("LAST_LOGIN_TIME between", value1, value2, "lastLoginTime");
            return (Criteria) this;
        }
        public Criteria andLastLoginTimeNotBetween(String value1, String value2) {
            addCriterion("LAST_LOGIN_TIME not between", value1, value2, "lastLoginTime");
            return (Criteria) this;
        }
		public Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (Criteria) this;
        }
        public Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (Criteria) this;
        }
        public Criteria andCreateTimeEqualTo(String value) {
            addCriterion("CREATE_TIME =", value, "createTime");
            return (Criteria) this;
        }
        public Criteria andCreateTimeNotEqualTo(String value) {
            addCriterion("CREATE_TIME <>", value, "createTime");
            return (Criteria) this;
        }
        public Criteria andCreateTimeGreaterThan(String value) {
            addCriterion("CREATE_TIME >", value, "createTime");
            return (Criteria) this;
        }
        public Criteria andCreateTimeGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_TIME >=", value, "createTime");
            return (Criteria) this;
        }
        public Criteria andCreateTimeLessThan(String value) {
            addCriterion("CREATE_TIME <", value, "createTime");
            return (Criteria) this;
        }
        public Criteria andCreateTimeLessThanOrEqualTo(String value) {
            addCriterion("CREATE_TIME <=", value, "createTime");
            return (Criteria) this;
        }
        public Criteria andCreateTimeLike(String value) {
            addCriterion("CREATE_TIME like", value, "createTime");
            return (Criteria) this;
        }
        public Criteria andCreateTimeNotLike(String value) {
            addCriterion("CREATE_TIME not like", value, "createTime");
            return (Criteria) this;
        }
        public Criteria andCreateTimeIn(List<String> values) {
            addCriterion("CREATE_TIME in", values, "createTime");
            return (Criteria) this;
        }
        public Criteria andCreateTimeNotIn(List<String> values) {
            addCriterion("CREATE_TIME not in", values, "createTime");
            return (Criteria) this;
        }
        public Criteria andCreateTimeBetween(String value1, String value2) {
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
            return (Criteria) this;
        }
        public Criteria andCreateTimeNotBetween(String value1, String value2) {
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
            return (Criteria) this;
        }
		public Criteria andModifyTimeIsNull() {
            addCriterion("MODIFY_TIME is null");
            return (Criteria) this;
        }
        public Criteria andModifyTimeIsNotNull() {
            addCriterion("MODIFY_TIME is not null");
            return (Criteria) this;
        }
        public Criteria andModifyTimeEqualTo(String value) {
            addCriterion("MODIFY_TIME =", value, "modifyTime");
            return (Criteria) this;
        }
        public Criteria andModifyTimeNotEqualTo(String value) {
            addCriterion("MODIFY_TIME <>", value, "modifyTime");
            return (Criteria) this;
        }
        public Criteria andModifyTimeGreaterThan(String value) {
            addCriterion("MODIFY_TIME >", value, "modifyTime");
            return (Criteria) this;
        }
        public Criteria andModifyTimeGreaterThanOrEqualTo(String value) {
            addCriterion("MODIFY_TIME >=", value, "modifyTime");
            return (Criteria) this;
        }
        public Criteria andModifyTimeLessThan(String value) {
            addCriterion("MODIFY_TIME <", value, "modifyTime");
            return (Criteria) this;
        }
        public Criteria andModifyTimeLessThanOrEqualTo(String value) {
            addCriterion("MODIFY_TIME <=", value, "modifyTime");
            return (Criteria) this;
        }
        public Criteria andModifyTimeLike(String value) {
            addCriterion("MODIFY_TIME like", value, "modifyTime");
            return (Criteria) this;
        }
        public Criteria andModifyTimeNotLike(String value) {
            addCriterion("MODIFY_TIME not like", value, "modifyTime");
            return (Criteria) this;
        }
        public Criteria andModifyTimeIn(List<String> values) {
            addCriterion("MODIFY_TIME in", values, "modifyTime");
            return (Criteria) this;
        }
        public Criteria andModifyTimeNotIn(List<String> values) {
            addCriterion("MODIFY_TIME not in", values, "modifyTime");
            return (Criteria) this;
        }
        public Criteria andModifyTimeBetween(String value1, String value2) {
            addCriterion("MODIFY_TIME between", value1, value2, "modifyTime");
            return (Criteria) this;
        }
        public Criteria andModifyTimeNotBetween(String value1, String value2) {
            addCriterion("MODIFY_TIME not between", value1, value2, "modifyTime");
            return (Criteria) this;
        }
	}
	/**
	 */
	public static class Criteria extends GeneratedCriteria {
	protected Criteria() {
			super();
		}
	}
	public static class Criterion {
		private String condition;
		private Object value;
		private Object secondValue;
		private boolean noValue;
		private boolean singleValue;
		private boolean betweenValue;
		private boolean listValue;
		private String typeHandler;
		public String getCondition() {
			return condition;
		}
		public Object getValue() {
			return value;
		}
		public Object getSecondValue() {
			return secondValue;
		}
		public boolean isNoValue() {
			return noValue;
		}
		public boolean isSingleValue() {
			return singleValue;
		}
		public boolean isBetweenValue() {
			return betweenValue;
		}
		public boolean isListValue() {
			return listValue;
		}
		public String getTypeHandler() {
			return typeHandler;
		}
		protected Criterion(String condition) {
			super();
			this.condition = condition;
			this.typeHandler = null;
			this.noValue = true;
		}
		protected Criterion(String condition, Object value, String typeHandler) {
			super();
			this.condition = condition;
			this.value = value;
			this.typeHandler = typeHandler;
			if (value instanceof List<?>) {
				this.listValue = true;
			} else {
				this.singleValue = true;
			}
		}
		protected Criterion(String condition, Object value) {
			this(condition, value, null);
		}
		protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
			super();
			this.condition = condition;
			this.value = value;
			this.secondValue = secondValue;
			this.typeHandler = typeHandler;
			this.betweenValue = true;
		}
		protected Criterion(String condition, Object value, Object secondValue) {
			this(condition, value, secondValue, null);
		}
	}
}